You are here: Pega 7 Platform Database > Database tables and columns > Property optimization > Populating database columns using the service-enabled Column Populator utility

Populating database columns by using the service-enabled Column Populator utility

You can use the prpcServiceUtils tool to expose a property as a database column and have the system populate the newly exposed column automatically, or extract a property value from the Storage Stream or pzInskey (BLOB) column into a newly added table column.

The prpcServiceUtils.bat or prpcServiceUtils.sh script can also rebuild Index- instances that are defined by Declare Index rules.

This improves performance when you have a running instance of the Pega 7 Platform in comparison with performing the same process using the Database Column Populator utility, which requires a connection to the database.

To expose a property as a database column, follow these steps:

  1. Configure the classes.

    To specify the data to expose, Use the include and exclude classes. For example, if you include Rule- with descendants and exclude Rule-File- with descendants, the Pega 7 Platform processes everything in Rule-, except rules in Rule-File-.

  2. To regenerate indexes, enter an access group or the REST user name and password (prpc.rest.proxy.username and prpc.rest.proxy.password in the common properties section). If you enter both an access group and a user name, the user name takes precedence over the access group.

  3. Save and close the prpcServiceUtils.properties file.

  4. Run the prpcServiceUtils.bat or prpcServiceUtils.sh script. For example:

    prpcServiceUtils.bat expose

    For asynchronous operations, the system response includes the job status by job ID.